<%@page import="java.sql.*,studentportal.*"%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>

<body  background="Stdbackground.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">
<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table  align="center" border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="23%">
      <p align="center"><a href="CollegeHome.html">About College</a></td>
    <td width="17%">
      <p align="center"><a href="AdminLogin.html">Admin</a></td>
   
    <td width="20%">
      <p align="center"><a href="StudentLogin.html">Students</a></td>

    <td width="20%">
      <p align="center"><a href="FacultyHome.html">Faculty</a></td>

    <td width="20%">
      <p align="center"><a href="AdmissionsHome.html">Admissions</a></td>

    <td width="20%">
      <p align="center"><a href="CorporatesLogin.html">Corporate</a></td>
  </tr>
</table>


<p align="center">&nbsp;</p>
<form method="POST" action="./StudentMasterServlet">
  <%
					
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sr="SELECT * FROM course_master order by course_id";
					System.out.println(sr);
					ResultSet rs=st.executeQuery(sr);
%>
  <div align="center">
    <center>
    <table border="1" width="68%" bordercolor="#0000FF">
			<tr>
					<th nowrap>Course ID</th>
					<th>Name </th>
					<th>Short Name</th>
					<th>Description</th>
					<th>Fee</th>
			</tr>
			<%
					while(rs.next())
					{
			%>
						<tr>
								<td><%=rs.getString(1)%></td>
								<td><%=rs.getString(2)%></td>
								<td><%=rs.getString(3)%></td>
								<td><%=rs.getString(4)%></td>
								<td><%=rs.getString(5)%></td>						
						</tr>
			<%
					}con.close();
			%>
	</table>
    </center>
  </div>
</form>
<p align="left">&nbsp;</p>


</body>

</html>
